{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":205,"n_cols":7,"rows_kept":205,"cut":false,"hidden":false,"merged":[]}
["PBM Part Number Configurator"]
["For Sanitary Igenix ZG Series 8 & 9 Z-Balls"]
[null,"Valve Part Number:",{"$f":"MID(C6,1,2)&MID(C7,1,2)&MID(C8,1,1)&MID(C9,1,1)&MID(C10,1,2)&MID(C11,1,1)&MID(C12,1,1)&MID(C13,1,1)&MID(C14,1,1)&MID(C15,1,2)&MID(C16,1,1)&MID(C17,1,1)","v":"ZG9"}]
[null,null,null,null,null,{"$f":"MID(C7,1,2)","v":""},"SI = Sanitary 2-way 3-piece ball valve, live loaded stem packing"]
["Position","Description","Click in field and select from menu",null,null,{"$f":"MID(C30,1,1)","v":""},"SI = Sanitary 2-way 3-piece ball valve, live loaded stem packing"]
["1-2","Product Series","ZG = Z-Ball valve, 2-way 3-piece, live loaded stem packing",null,null,{"$f":"MID(C30,5,1)","v":""}]
["3-4","Material"]
["5","Valve Size",null,null,null,null,"TF = V-TEF™"]
["6","Series",{"$f":"IF(F4=\"HF\",F25,F26)","v":"9 = PBM Series 9, Igenix® True Bore® Sanitary Cast - Low Ferrite Content"},null,null,null,"HT = S-TEF®"]
["7-8","Manifold X Valve End Connections",null,null,null,"HF = A182, F316L / EN 1.4404 and / or A479, S31603 Body & Ends, 316L Ball, and Stem","UT = UHMWPE"]
["9","Seat / Filler Material",null,null,null,"HL = A351, CF3M and / or A479, S31603 Body & Ends, 316L Ball, and Stem","TF =  VTFE Cavity Fillers Only"]
["10","Purge Ports (Valve Only)",null,null,null,"C- = Hastelloy C-276  Body, Ends, Ball, and Stem"]
["11","Ball Flats, Purge Holes (Valve Only)",null,null,null,"P- = AL6XN  Body, Ends, Ball, and Stem"]
["12","Manifold X Valve Size Options",null,null,null,"Y- = Hastelloy C-22  Body, Ends, Ball, and Stem"]
["13-14","Operator"]
["15","Polish",null,null,null,null,"C = 1/2 inch"]
["16","LOX Cleaning",null,null,null,"C = 1/2 inch","D = 3/4 inch"]
[null,null,null,null,null,"D = 3/4 inch","E = 1 inch"]
[null,null,"`",null,null,"E = 1 inch","G = 1-1/2 inch"]
["PBM Repair Kit Part Number Configurator",null,null,null,null,"G = 1-1/2 inch","H = 2 inch"]
["For Sanitary Igenix ZG Series 8 & 9 Z-Balls",null,null,null,null,"H = 2 inch"]
[null,"    Repair Kit Part Number:",{"$f":"MID(C25,1,2)&MID(C26,1,2)&MID(C27,1,1)&MID(C28,1,1)&MID(C29,1,2)&MID(C30,1,1)&MID(C31,1,2)&MID(C32,1,1)","v":"SI 8----1"}]
[null,null,null,null,null,null,"G = V-TEF™ seats and seals, Adjust-O-Seal®"]
["Position","Description","Click in field and select from menu (Material Code and Size Only)",null,null,null,"H = S-TEF® seats and seals, Adjust-O-Seal®"]
["1-2","Product Series",{"$f":"IF(F5=\"J\",G5,IF(F5=\"M\",G5,IF(F5=\"P\",G5,G4)))","v":"SI = Sanitary 2-way 3-piece ball valve, live loaded stem packing"},null,null,"8 = PBM Series 8, Igenix® True Bore® Sanitary Forged - Low Ferrite Content","K = UHMWPE seats and seals, Adjust-O-Seal®"]
["3-4","Material",{"$f":"IF(F6=\"V\",G8,IF(F6=\"S\",G9,IF(F6=\"U\",G10,IF(F6=\"P\",#REF!,IF(F6=\" \",G11,\" \")))))","v":" "},null,null,"9 = PBM Series 9, Igenix® True Bore® Sanitary Cast - Low Ferrite Content","J =  VTFE cavity fillers"]
["5","Size",null,null,null,null,"M = UHMWPE cavity fillers"]
["6","Series","8 = PBM Series 8 or Series 9"]
["7-8"," - -","-- = dashes only, no options to select"]
["9","Material Code",null,null,null,"FF = Extended Butt weld for tube end (Manifold) by Extended Butt weld for tube end (Valve)","1 = (1) complete repair kit"]
["10-11"," - - ","-- = dashes only, no options to select",null,null,"FX =  Extended Butt weld for tube end (Manifold) by Hygienic Clamp for tube end (Valve)","3 = (3) complete filler kit"]
["12","Kit Code",{"$f":"IF(F5=\"J\",G31,IF(F5=\"M\",G31,IF(F5=\"P\",G31,G30)))","v":"1 = (1) complete repair kit"},null,null,"FS = Extended Butt weld for tube end (Manifold) by Compression end (Valve - 1\" MAX.)"]
["R0",null,null,null,null,"XF = Hygenic Clamp for tube end (Manifold) by Extended Butt weld for tube end (Valve)"]
["2021-12-20",null,null,null,null,"XX = Hygenic Clamp for tube end (Manifold) by Hygienic Clamp for tube end (Valve)"]
[null,null,null,null,null,"XS = Hygenic Clamp for tube end (Manifold) by Compression end (Valve - 1\" MAX.)"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"G = V-TEF™ seats and seals, no cavity filler, Adjust-O-Seal®"]
[null,null,null,null,null,"J = V-TEF™ seats and seals, VTFE cavity filler, Adjust-O-Seal®"]
[null,null,null,null,null,"H = S-TEF® seats and seals, no cavity filler, Adjust-O-Seal®"]
[null,null,null,null,null,"I = S-TEF® seats and seals, VTFE cavity filler, Adjust-O-Seal®"]
[null,null,null,null,null,"K = UHMWPE seats and seals, no cavity filler, Adjust-O-Seal®"]
[null,null,null,null,null,"L = UHMWPE seats and seals, VTFE cavity filler, Adjust-O-Seal®"]
[null,null,null,null,null,"M = UHMWPE seats and seals, UHMWPE cavity filler, Adjust-O-Seal®"]
[]
[]
[]
[null,null,null,null,null,"- = no purge ports required"]
[null,null,null,null,null,"A = (1) 1/2\" sanitary clamp on center, 90 degrees from stem"]
[null,null,null,null,null,"B = (1) 1/2\" sanitary clamp on center, opposite stem"]
[null,null,null,null,null,"C = (1) 1/2\" sanitary clamp upstream, 90 degrees from stem"]
[null,null,null,null,null,"D = (1) 1/2\" sanitary clamp downstream opposite stem"]
[null,null,null,null,null,"E = (2) 1/2\" sanitary clamps on center 90 deg from & opposite stem"]
[null,null,null,null,null,"F = (2) 1/2\" sanitary clamps upstream 90 deg from & downstream opp stem"]
[null,null,null,null,null,"G = (1) 1/2\" BWTE stub on center, 90 degrees from stem"]
[null,null,null,null,null,"H = (1) 1/2\" BWTE stub on center, opposite stem"]
[null,null,null,null,null,"I = (1) 1/2\" BWTE stub upstream, 90 degrees from stem"]
[null,null,null,null,null,"J = (1) 1/2\" BWTE stub downstream opposite stem"]
[null,null,null,null,null,"K = (2) 1/2\" BWTE stubs on center 90 deg from & opposite stem"]
[null,null,null,null,null,"L = (2) 1/2\" BWTE stubs upstream 90 deg from & downstream opp stem"]
[]
[]
[null,null,null,null,null,"- = no ball flats, ball purge holes, or V ball required"]
[null,null,null,null,null,"A = ball flats facing downstream in ball - closed position"]
[null,null,null,null,null,"B = ball flats facing upstream in ball - closed position"]
[null,null,null,null,null,"C = ball flats facing upstream in ball - open position"]
[null,null,null,null,null,"D = ball flats facing downstream in ball - open position"]
[null,null,null,null,null,"E = ball flats up & downstream in ball - open position"]
[null,null,null,null,null,"F = ball holes facing downstream in ball - closed position"]
[null,null,null,null,null,"G = ball holes facing upstream in ball - closed positon"]
[null,null,null,null,null,"H = ball holes facing upstream in ball -  open positon"]
[null,null,null,null,null,"I = ball holes facing downstream in ball - open position"]
[null,null,null,null,null,"J = ball holes up & downsteam in ball - open position"]
[null,null,null,null,null,"K = Ball with vent hole (downstream)"]
[null,null,null,null,null,"7 = Self-flushing ball with flats closed downstream"]
[null,null,null,null,null,"8 = Self-flushing ball"]
[null,null,null,null,null,"9 = Ball with vent hole (upstream)"]
[]
[]
[null,null,null,null,null,"A = Manifold and Valve Same Size"]
[null,null,null,null,null,"B = 3/4 inch Manifold X 1/2 inch valve"]
[null,null,null,null,null,"C = 1 inch Manifold X 1/2 inch valve"]
[null,null,null,null,null,"D = 1 inch Manifold X 3/4 inch valve"]
[null,null,null,null,null,"E = 1-1/2 inch Manifold X 1/2 inch valve"]
[null,null,null,null,null,"F = 1-1/2 inch Manifold X 3/4 inch valve"]
[null,null,null,null,null,"G = 1-1/2 inch Manifold X 1 inch valve"]
[null,null,null,null,null,"H = 2 inch Manifold X 1/2 inch valve"]
[null,null,null,null,null,"J = 2 inch Manifold X 3/4 inch valve"]
[null,null,null,null,null,"K = 2 inch Manifold X 1 inch valve"]
[null,null,null,null,null,"L = 2 inch Manifold X 1-1/2 inch valve"]
[null,null,null,null,null,"M = 3 inch Manifold X 1/2 inch valve"]
[null,null,null,null,null,"M = 3 inch Manifold X 3/4 inch valve"]
[null,null,null,null,null,"P = 3 inch Manifold X 1 inch valve"]
[null,null,null,null,null,"Q = 3 inch Manifold X 1-1/2 inch valve"]
[null,null,null,null,null,"R = 3 inch Manifold X 2 inch valve"]
[]
[]
[]
[null,null,null,null,null,"- = No additional polish (30 Ra ID Standard)"]
[null,null,null,null,null,"A = 20 RA ID polish"]
[null,null,null,null,null,"B = 32 RA OD polish"]
[null,null,null,null,null,"C = 20 RA ID & 32 RA OD polish"]
[null,null,null,null,null,"D = 15 RA ID polish"]
[null,null,null,null,null,"E = 10 RA ID polish"]
[null,null,null,null,null,"F = 20 RA ID polish after electropolish"]
[null,null,null,null,null,"G = 15 RA ID polish after electropolish"]
[null,null,null,null,null,"H = 10 RA ID polish after electropolish"]
[null,null,null,null,null,"I = 5 RA ID polish"]
[null,null,null,null,null,"K = 5 RA ID & 32 RA OD polish"]
[null,null,null,null,null,"L = 20 RA ID & 32 RA OD polish after electropolish"]
[null,null,null,null,null,"M = Electropolish only (ID & OD)"]
[null,null,null,null,null,"N = 10 RA ID & 32 RA OD polish"]
[null,null,null,null,null,"O = 15 RA ID & 32 RA OD polish after electropolish"]
[null,null,null,null,null,"Q = 15 RA ID & 32 RA OD polish"]
[null,null,null,null,null,"S = 10 RA ID & 32 RA OD polish after electropolish"]
[]
[]
[null,null,null,null,null,"L = LOX cleaning per PBM procedure"]
[]
[]
[null,null,null,null,null,"-- = Manual lever handle"]
[null,null,null,null,null,"00 = manual locking oval handwheel"]
[null,null,null,null,null,"02 = less handle (stem ready for future automation)"]
[null,null,null,null,null,"03 = manual lever handle (stem ready for future automation)"]
[null,null,null,null,null,"04 = manual locking lever handle"]
[null,null,null,null,null,"05 = oval handwheel"]
[null,null,null,null,null,"07 = 45 degree handle"]
[null,null,null,null,null,"10 = Manual Spring Return Handle  (For 1/2\" through 1-1/2\" Valves Only)"]
[null,null,null,null,null,"11 = Fusible Link Spring Return Handle (temp rating required)"]
[null,null,null,null,null,"12 = Vane Actuator"]
[null,null,null,null,null,"13 = GP Electric Actuator"]
[null,null,null,null,null,"14 = XP Electric Actuator"]
[null,null,null,null,null,"71 = extended locking lever handle"]
[null,null,null,null,null,"72 = extended locking oval handwheel"]
[null,null,null,null,null,"20 = 80 PSIG DA PBM Actuator"]
[null,null,null,null,null,"21 = 80 PSIG DA PBM Actuator w/ GP Westlock Limit Switch"]
[null,null,null,null,null,"22 = 80 PSIG DA PBM Actuator w/ GP 110VAC Asco Solenoid"]
[null,null,null,null,null,"23 = 80 PSIG DA PBM Actuator w/ GP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,"24 = 80 PSIG DA PBM Actuator w/ XP Westlock Limit Switch"]
[null,null,null,null,null,"25 = 80 PSIG DA PBM Actuator w/ XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"26 = 80 PSIG DA PBM Actuator w/ XP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,"27 = 60 PSIG DA PBM Actuator"]
[null,null,null,null,null,"28 = 60 PSIG DA PBM Actuator w/ GP Westlock Limit Switch"]
[null,null,null,null,null,"29 = 60 PSIG DA PBM Actuator w/ GP 110VAC Asco Solenoid"]
[null,null,null,null,null,"30 = 60 PSIG DA PBM Actuator w/ GP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,"31 = 60 PSIG DA PBM Actuator w/ XP Westlock Limit Switch"]
[null,null,null,null,null,"32 = 60 PSIG DA PBM Actuator w/ XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"33 = 60 PSIG DA PBM Actuator w/ XP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,"34 = 80 PSIG SR PBM Actuator"]
[null,null,null,null,null,"35 = 80 PSIG SR PBM Actuator w/ GP Westlock Limit Switch"]
[null,null,null,null,null,"36 = 80 PSIG SR PBM Actuator w/ GP 110VAC Asco Solenoid"]
[null,null,null,null,null,"37 = 80 PSIG SR PBM Actuator w/ GP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,"38 = 80 PSIG SR PBM Actuator w/ XP Westlock Limit Switch"]
[null,null,null,null,null,"39 = 80 PSIG SR PBM Actuator w/ XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"40 = 80 PSIG SR PBM Actuator w/ XP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,"41 = 60 PSIG SR PBM Actuator"]
[null,null,null,null,null,"42 = 60 PSIG SR PBM Actuator w/ GP Westlock Limit Switch"]
[null,null,null,null,null,"43 = 60 PSIG SR PBM Actuator w/ GP 110VAC Asco Solenoid"]
[null,null,null,null,null,"44 = 60 PSIG SR PBM Actuator w/ GP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,"45 = 60 PSIG SR PBM Actuator w/ XP Westlock Limit Switch"]
[null,null,null,null,null,"46 = 60 PSIG SR PBM Actuator w/ XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"47 = 60 PSIG SR PBM Actuator w/ XP Westlock Limit Switch & 110VAC Asco Solenoid"]
[null,null,null,null,null,"51 = 80 PSIG DA PBM Actuator w/ Position Indicator"]
[null,null,null,null,null,"52 = 60 PSIG DA PBM Actuator w/ Position Indicator"]
[null,null,null,null,null,"53 = 80 PSIG SR PBM Actuator w/ Position Indicator"]
[null,null,null,null,null,"54 = 60 PSIG SR PBM Actuator w/ Position Indicator"]
[null,null,null,null,null,"55 = 80 PSIG DA PBM Actuator w/ GP 24VDC Asco Solenoid"]
[null,null,null,null,null,"56 = 80 PSIG DA PBM Actuator w/ GP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,"57 = 80 PSIG DA PBM Actuator w/ XP 24VDC Asco Solenoid"]
[null,null,null,null,null,"58 = 80 PSIG DA PBM Actuator w/ XP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,"59 = 60 PSIG DA PBM Actuator w/ GP 24VDC Asco Solenoid"]
[null,null,null,null,null,"60 = 60 PSIG DA PBM Actuator w/ GP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,"61 = 60 PSIG DA PBM Actuator w/ XP 24VDC Asco Solenoid"]
[null,null,null,null,null,"62 = 60 PSIG DA PBM Actuator w/ XP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,"63 = 80 PSIG SR PBM Actuator w/ GP 24VDC Asco Solenoid"]
[null,null,null,null,null,"64 = 80 PSIG SR PBM Actuator w/ GP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,"65 = 80 PSIG SR PBM Actuator w/ XP 24VDC Asco Solenoid"]
[null,null,null,null,null,"66 = 80 PSIG SR PBM Actuator w/ XP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,"67 = 60 PSIG SR PBM Actuator w/ GP 24VDC Asco Solenoid"]
[null,null,null,null,null,"68 = 60 PSIG SR PBM Actuator w/ GP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,"69 = 60 PSIG SR PBM Actuator w/ XP 24VDC Asco Solenoid"]
[null,null,null,null,null,"70 = 60 PSIG SR PBM Actuator w/ XP Westlock Limit Switch & 24VDC Asco Solenoid"]
[null,null,null,null,null,"73 = 80 PSIG DA PBM Actuator w/ XP Topworx Limit Switch"]
[null,null,null,null,null,"74 = 80 PSIG DA PBM Actuator w/ XP Topworx Limit Switch & GP 110VAC Asco Solenoid"]
[null,null,null,null,null,"75 = 80 PSIG DA PBM Actuator w/ XP Topworx Limit Switch & XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"76 = 60 PSIG DA PBM Actuator w/ XP Topworx Limit Switch"]
[null,null,null,null,null,"77 = 60 PSIG DA PBM Actuator w/ XP Topworx Limit Switch & GP 110VAC Asco Solenoid"]
[null,null,null,null,null,"78 = 60 PSIG DA PBM Actuator w/ XP Topworx Limit Switch & XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"79 = 80 PSIG SR PBM Actuator w/ XP Topworx Limit Switch"]
[null,null,null,null,null,"80 = 80 PSIG SR PBM Actuator w/ XP Topworx Limit Switch & GP 110VAC Asco Solenoid"]
[null,null,null,null,null,"81 = 80 PSIG SR PBM Actuator w/ XP Topworx Limit Switch & XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"82 = 60 PSIG SR PBM Actuator w/ XP Topworx Limit Switch"]
[null,null,null,null,null,"83 = 60 PSIG SR PBM Actuator w/ XP Topworx Limit Switch & GP 110VAC Asco Solenoid"]
[null,null,null,null,null,"84 = 60 PSIG SR PBM Actuator w/ XP Topworx Limit Switch & XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"85 = 80 PSIG DA PBM Actuator w/ XP Topworx Proximity Switch"]
[null,null,null,null,null,"86 = 80 PSIG DA PBM Actuator w/ XP Topworx Proximity Switch & XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"87 = 60 PSIG DA PBM Actuator w/ XP Topworx Proximity Switch"]
[null,null,null,null,null,"88 = 60 PSIG DA PBM Actuator w/ XP Topworx Proximity Switch & XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"89 = 80 PSIG SR PBM Actuator w/ XP Topworx Proximity Switch"]
[null,null,null,null,null,"90 = 80 PSIG SR PBM Actuator w/ XP Topworx Proximity Switch & XP 110VAC Asco Solenoid"]
[null,null,null,null,null,"91 = 60 PSIG SR PBM Actuator w/ XP Topworx Proximity Switch"]
[null,null,null,null,null,"92 = 60 PSIG SR PBM Actuator w/ XP Topworx Proximity Switch & XP 110VAC Asco Solenoid"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}